You are here: Accounting Interface > Xero API Accounting Interface > Bank Reconciliation in Xero

Bank Reconciliation in Xero

The Xero API Integration has been superseded by the Xero OAUTH2 Integration.
Please refer to the Xero OAUTH2 topic for information on setting up Xero with Idealpos.
This page has not been removed for historical and reference purposes.
The steps included on this page may no longer be valid, and therefore, we encourage you to refer to the Xero OAUTH2 topic.

After the sales are transferred from Idealpos to Xero, a Bank Reconciliation is performed to reconcile the bank accounts.

 

31 August 2016

Following the day’s trade (e.g. 31 Aug 2016), Idealpos will post the transaction journals to Xero.

 

The day’s trade netted $1,318.95 (Image 1) made up as follows:

 

Image 1

 

1 September 2016

Owner’s bank will settle EFT receipts (from 31 Aug 2016) into the business’ bank account

Owner will physically deposit cash received (from 31 Aug 2016)

 

2 September 2016

Xero will import the bank transactions from the business’ bank account (via automated bank feeds)

The Owner will reconcile the funds received as in the example (Image 2) by matching up the transactions showing on the bank account (which appear on the left hand column of the screen) and “matching” them to the relevant accounts on the right hand side of the screen.

 

The first time that the business owner does a reconciliation of the POS transactions they will need to click on the “create” tab on the right had side of the screen and choose the correct EFTPOS or Undeposited Funds accounts to allocate the transaction to.  From then on Xero recognises the description from the bank transaction line and should suggest the appropriate account the transaction should be allocated to.  If this is not occurring the Owner can create bank rules to help with this process. See attached link for more information on bank rules.

 

https://help.xero.com/au/BankAccounts_Details_BankRules

 

The Owner will just need to check that they are happy with the allocation Xero has suggested and then they just need to click “OK” to reconcile the transaction.

After reconciling, the funds will clear the Undeposited Funds and EFTPOS accounts to nil. The bank account will show the balance that has been banked.

 

Ordinarily there is a day or two of timing differences between when the sale happens and the actual funds are received in the bank account - i.e.:

 

Image 2